Danielle Arteaga
Danielle Arteaga
-
Re: How to JOIN multiple columns without delimiters
Assuming your set up looks something like this: If you want the join only if Performer is not blank, try this formula in the Join column: =IF(ISBLANK(Performer@row), "", JOIN(Performer@row …1 · -
Re: Formula for ranking top 3 names/nominees in a text/number column
The ease of doing this depends a lot on how many nominees you have and the structure of your sheet. But, assuming you can identify the list of possible candidates, here's one approach. Create a sheet…1 · -
Re: Complex Logic Statements
Assuming your set up looks something like this: Place this formula in the [Audit Cost] column: =IF(AND([Length of Audit]@row = 2, [Audit Location]@row = "Onsite"), 15000, IF(AND([Length of …1 · -
Re: Do you use Smartsheet for your personal life? If so, how?
I do! I am a half marathon enthusiast. Although there are a ton of running apps out there, none of them really organize things or track things the way I want. Most of them support only one-size-fits-…3 · -
Re: February Question of the Month - Join the conversation and receive a badge
When I was a kid, I wanted to be the first woman President of the United States. I wrote an essay about this in the 6th grade. For some reason, I believed I needed to become a lawyer as the first ste…9 ·
